﻿CREATE TABLE [dbo].[CurrencyInstrument] (
    [Id]         INT           NOT NULL CONSTRAINT [FK_CurrencyInstrument] FOREIGN KEY ([Id]) REFERENCES [dbo].[Instrument] ([Id]),
    --[Version]    ROWVERSION    NOT NULL,
    --[ModifiedBy] INT           NOT NULL,
    --[ModifiedDt] DATETIME      NOT NULL,
    
	[Code]       CHAR (3)      NOT NULL CONSTRAINT [UX_CurrencyInstrument_Code] UNIQUE NONCLUSTERED ([Code] ASC),
    --[Name]       VARCHAR (255) NOT NULL,
    CONSTRAINT [PK_CurrencyInstrument] PRIMARY KEY CLUSTERED ([Id] ASC)    
);

